home *** CD-ROM | disk | FTP | other *** search
/ Precision Software Appli…tions Silver Collection 1 / Precision Software Applications Silver Collection Volume One (PSM) (1993).iso / tutor / lotus1ad.exe / QUOTE.EVL < prev    next >
Text File  |  1991-02-28  |  2KB  |  39 lines
  1.  
  2. Problem  Menu-driven quote generator.  User selects items to be included
  3.          in quote by entering a number in a "QTY" column within a
  4.          database.  Database is simply a list of all items available for
  5.          sale.  Fields are set up for the following items: Part No, Qty,
  6.          Descr, Unit price, Total price, Unit cost, Total cost, and GP%.
  7.          See doc in AUTO123 file (7202) for some general tips on studying
  8.          this application.
  9.  
  10. Block Diagram
  11.                __________________ __________________ _________________
  12.               |                  |                  |                 |
  13.               |                  |                  |    Menu         |
  14.               |                  |    Quote         |_________________|
  15.               |                  |                  |                 |
  16.               |    Database      |                  |    Macros       |
  17.               |                  |__________________|                 |
  18.               |                  |                  |                 |
  19.               |                  |                  |                 |
  20.               |__________________|                  |_________________|
  21.  
  22.  
  23. Tips
  24.          Macros begin at cell R22
  25.          Main menu technique is unique.
  26.          Option 1 uses Range Input command R25.
  27.          Macro for generating quote S24.  Also look at Data Query
  28.            setting.
  29.          Modify database macro techniques S48.
  30.  
  31.  
  32.  
  33.  
  34.  
  35.  
  36.  
  37.  
  38. 
  39.